Tabela LContractStatus

Definicja tabeli LContractStatus

Name

LContractStatus

Code

LContractStatus

Comment

PL: Polaczenie umowy ze statusem i przyczyna blokady – tworzony przy blokadzie i zawieszeniu umowy
EN: Link between contract and blockade status and reason – will be created for contract blockades and hangs


Lista kolumn tabeli LContractStatus

Name

Code

LContractStatusID

LContractStatusID

ContractBlockTypeID

ContractBlockTypeID

ContractID

ContractID

CancelReasonID

CancelReasonID

StartDT

StartDT

StopDT

StopDT


Kolumna LContractStatusID tabeli LContractStatus

Definicja kolumny LContractStatusID tabeli LContractStatus

Name

LContractStatusID

Code

LContractStatusID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractBlockTypeID tabeli LContractStatus

Definicja kolumny ContractBlockTypeID tabeli LContractStatus

Name

ContractBlockTypeID

Code

ContractBlockTypeID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna ContractID tabeli LContractStatus

Definicja kolumny ContractID tabeli LContractStatus

Name

ContractID

Code

ContractID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna CancelReasonID tabeli LContractStatus

Definicja kolumny CancelReasonID tabeli LContractStatus

Name

CancelReasonID

Code

CancelReasonID

Data Type

NUMBER(10)

Mandatory

Yes

Comment

 


Kolumna StartDT tabeli LContractStatus

Definicja kolumny StartDT tabeli LContractStatus

Name

StartDT

Code

StartDT

Data Type

DATE

Mandatory

No

Comment

PL: Data poczatku
EN: Start date
DE: das Beginndatum


Kolumna StopDT tabeli LContractStatus

Definicja kolumny StopDT tabeli LContractStatus

Name

StopDT

Code

StopDT

Data Type

DATE

Mandatory

No

Comment

PL: Data koncowa
EN: Stop date
DE: Das Endedatum


Lista kluczy tabeli LContractStatus

Name

Code

Primary

Identifier_1

Identifier_1

X


Klucz Identifier_1 tabeli LContractStatus

Definicja klucza Identifier_1 tabeli LContractStatus

Name

Identifier_1

Code

Identifier_1

Primary

Yes

Comment